﻿/**  版本信息模板在安装目录下，可自行修改。
* FA_MASTERDATA_EXCEL_JW.cs
*
* 功 能： N/A
* 类 名： FA_MASTERDATA_EXCEL_JW
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013/10/14 11:17:13   N/A    初版
*
* Copyright (c) 2012 TKFA Corporation. All rights reserved.
*┌──────────────────────────────────┐
*│　此技术信息为本公司机密信息，未经本公司书面同意禁止向第三方披露．　│
*│　版权所有：TKFA　　　　　　　　　　　　　　│
*└──────────────────────────────────┘
*/
using System;
using System.Data;
using System.Text;
using System.Data.OracleClient;
using TKFA.IDAL;
using Maticsoft.DBUtility;//Please add references
namespace TKFA.OracleDAL
{
	/// <summary>
	/// 数据访问类:FA_MASTERDATA_EXCEL_JW
	/// </summary>
	public partial class FA_MASTERDATA_EXCEL_JW:IFA_MASTERDATA_EXCEL_JW
	{
		public FA_MASTERDATA_EXCEL_JW()
		{}
		#region  BasicMethod



		/// <summary>
		/// 增加一条数据
		/// </summary>
		public bool Add(TKFA.Model.FA_MASTERDATA_EXCEL_JW model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into FA_MASTERDATA_EXCEL_JW(");
			strSql.Append("SCORPCODE,SMASTERCARDCODE,COLUMN2,COLUMN3,COLUMN4,COLUMN5,COLUMN6,COLUMN7,COLUMN8,COLUMN9,COLUMN10,COLUMN11,COLUMN12,COLUMN13,COLUMN14,COLUMN15,COLUMN16,COLUMN17,COLUMN18,COLUMN19,COLUMN20,COLUMN21,COLUMN22,COLUMN23,COLUMN24,COLUMN25,COLUMN26,COLUMN27,COLUMN28,COLUMN29,COLUMN30,COLUMN31,COLUMN32,COLUMN33,COLUMN34,COLUMN35,COLUMN36,COLUMN37,COLUMN38,COLUMN39,COLUMN40,COLUMN41,COLUMN42,COLUMN43,COLUMN44,COLUMN45,COLUMN46,COLUMN47,COLUMN48,COLUMN49,COLUMN50,COLUMN51,COLUMN52,COLUMN53,COLUMN54,COLUMN55,COLUMN56)");
			strSql.Append(" values (");
			strSql.Append(":SCORPCODE,:SMASTERCARDCODE,:COLUMN2,:COLUMN3,:COLUMN4,:COLUMN5,:COLUMN6,:COLUMN7,:COLUMN8,:COLUMN9,:COLUMN10,:COLUMN11,:COLUMN12,:COLUMN13,:COLUMN14,:COLUMN15,:COLUMN16,:COLUMN17,:COLUMN18,:COLUMN19,:COLUMN20,:COLUMN21,:COLUMN22,:COLUMN23,:COLUMN24,:COLUMN25,:COLUMN26,:COLUMN27,:COLUMN28,:COLUMN29,:COLUMN30,:COLUMN31,:COLUMN32,:COLUMN33,:COLUMN34,:COLUMN35,:COLUMN36,:COLUMN37,:COLUMN38,:COLUMN39,:COLUMN40,:COLUMN41,:COLUMN42,:COLUMN43,:COLUMN44,:COLUMN45,:COLUMN46,:COLUMN47,:COLUMN48,:COLUMN49,:COLUMN50,:COLUMN51,:COLUMN52,:COLUMN53,:COLUMN54,:COLUMN55,:COLUMN56)");
			OracleParameter[] parameters = {
					new OracleParameter(":SCORPCODE", OracleType.VarChar,20),
					new OracleParameter(":SMASTERCARDCODE", OracleType.VarChar,20),
					new OracleParameter(":COLUMN2", OracleType.VarChar,50),
					new OracleParameter(":COLUMN3", OracleType.VarChar,80),
					new OracleParameter(":COLUMN4", OracleType.VarChar,20),
					new OracleParameter(":COLUMN5", OracleType.VarChar,20),
					new OracleParameter(":COLUMN6", OracleType.VarChar,20),
					new OracleParameter(":COLUMN7", OracleType.VarChar,20),
					new OracleParameter(":COLUMN8", OracleType.VarChar,200),
					new OracleParameter(":COLUMN9", OracleType.VarChar,80),
					new OracleParameter(":COLUMN10", OracleType.VarChar,20),
					new OracleParameter(":COLUMN11", OracleType.VarChar,20),
					new OracleParameter(":COLUMN12", OracleType.VarChar,20),
					new OracleParameter(":COLUMN13", OracleType.VarChar,20),
					new OracleParameter(":COLUMN14", OracleType.VarChar,20),
					new OracleParameter(":COLUMN15", OracleType.VarChar,20),
					new OracleParameter(":COLUMN16", OracleType.VarChar,20),
					new OracleParameter(":COLUMN17", OracleType.VarChar,80),
					new OracleParameter(":COLUMN18", OracleType.VarChar,80),
					new OracleParameter(":COLUMN19", OracleType.VarChar,20),
					new OracleParameter(":COLUMN20", OracleType.VarChar,20),
					new OracleParameter(":COLUMN21", OracleType.VarChar,20),
					new OracleParameter(":COLUMN22", OracleType.VarChar,20),
					new OracleParameter(":COLUMN23", OracleType.VarChar,20),
					new OracleParameter(":COLUMN24", OracleType.VarChar,20),
					new OracleParameter(":COLUMN25", OracleType.VarChar,20),
					new OracleParameter(":COLUMN26", OracleType.VarChar,80),
					new OracleParameter(":COLUMN27", OracleType.VarChar,20),
					new OracleParameter(":COLUMN28", OracleType.VarChar,80),
					new OracleParameter(":COLUMN29", OracleType.VarChar,80),
					new OracleParameter(":COLUMN30", OracleType.VarChar,20),
					new OracleParameter(":COLUMN31", OracleType.VarChar,20),
					new OracleParameter(":COLUMN32", OracleType.VarChar,20),
					new OracleParameter(":COLUMN33", OracleType.VarChar,20),
					new OracleParameter(":COLUMN34", OracleType.VarChar,20),
					new OracleParameter(":COLUMN35", OracleType.VarChar,20),
					new OracleParameter(":COLUMN36", OracleType.VarChar,20),
					new OracleParameter(":COLUMN37", OracleType.VarChar,20),
					new OracleParameter(":COLUMN38", OracleType.VarChar,20),
					new OracleParameter(":COLUMN39", OracleType.VarChar,20),
					new OracleParameter(":COLUMN40", OracleType.VarChar,80),
					new OracleParameter(":COLUMN41", OracleType.VarChar,20),
					new OracleParameter(":COLUMN42", OracleType.VarChar,20),
					new OracleParameter(":COLUMN43", OracleType.VarChar,20),
					new OracleParameter(":COLUMN44", OracleType.VarChar,20),
					new OracleParameter(":COLUMN45", OracleType.VarChar,20),
					new OracleParameter(":COLUMN46", OracleType.VarChar,20),
					new OracleParameter(":COLUMN47", OracleType.VarChar,80),
					new OracleParameter(":COLUMN48", OracleType.VarChar,80),
					new OracleParameter(":COLUMN49", OracleType.VarChar,20),
					new OracleParameter(":COLUMN50", OracleType.VarChar,20),
					new OracleParameter(":COLUMN51", OracleType.VarChar,20),
					new OracleParameter(":COLUMN52", OracleType.VarChar,20),
					new OracleParameter(":COLUMN53", OracleType.VarChar,20),
					new OracleParameter(":COLUMN54", OracleType.VarChar,20),
					new OracleParameter(":COLUMN55", OracleType.VarChar,80),
					new OracleParameter(":COLUMN56", OracleType.VarChar,80)};
			parameters[0].Value = model.SCORPCODE;
			parameters[1].Value = model.SMASTERCARDCODE;
			parameters[2].Value = model.COLUMN2;
			parameters[3].Value = model.COLUMN3;
			parameters[4].Value = model.COLUMN4;
			parameters[5].Value = model.COLUMN5;
			parameters[6].Value = model.COLUMN6;
			parameters[7].Value = model.COLUMN7;
			parameters[8].Value = model.COLUMN8;
			parameters[9].Value = model.COLUMN9;
			parameters[10].Value = model.COLUMN10;
			parameters[11].Value = model.COLUMN11;
			parameters[12].Value = model.COLUMN12;
			parameters[13].Value = model.COLUMN13;
			parameters[14].Value = model.COLUMN14;
			parameters[15].Value = model.COLUMN15;
			parameters[16].Value = model.COLUMN16;
			parameters[17].Value = model.COLUMN17;
			parameters[18].Value = model.COLUMN18;
			parameters[19].Value = model.COLUMN19;
			parameters[20].Value = model.COLUMN20;
			parameters[21].Value = model.COLUMN21;
			parameters[22].Value = model.COLUMN22;
			parameters[23].Value = model.COLUMN23;
			parameters[24].Value = model.COLUMN24;
			parameters[25].Value = model.COLUMN25;
			parameters[26].Value = model.COLUMN26;
			parameters[27].Value = model.COLUMN27;
			parameters[28].Value = model.COLUMN28;
			parameters[29].Value = model.COLUMN29;
			parameters[30].Value = model.COLUMN30;
			parameters[31].Value = model.COLUMN31;
			parameters[32].Value = model.COLUMN32;
			parameters[33].Value = model.COLUMN33;
			parameters[34].Value = model.COLUMN34;
			parameters[35].Value = model.COLUMN35;
			parameters[36].Value = model.COLUMN36;
			parameters[37].Value = model.COLUMN37;
			parameters[38].Value = model.COLUMN38;
			parameters[39].Value = model.COLUMN39;
			parameters[40].Value = model.COLUMN40;
			parameters[41].Value = model.COLUMN41;
			parameters[42].Value = model.COLUMN42;
			parameters[43].Value = model.COLUMN43;
			parameters[44].Value = model.COLUMN44;
			parameters[45].Value = model.COLUMN45;
			parameters[46].Value = model.COLUMN46;
			parameters[47].Value = model.COLUMN47;
			parameters[48].Value = model.COLUMN48;
			parameters[49].Value = model.COLUMN49;
			parameters[50].Value = model.COLUMN50;
			parameters[51].Value = model.COLUMN51;
			parameters[52].Value = model.COLUMN52;
			parameters[53].Value = model.COLUMN53;
			parameters[54].Value = model.COLUMN54;
			parameters[55].Value = model.COLUMN55;
			parameters[56].Value = model.COLUMN56;

			int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}
		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(TKFA.Model.FA_MASTERDATA_EXCEL_JW model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update FA_MASTERDATA_EXCEL_JW set ");
			strSql.Append("SCORPCODE=:SCORPCODE,");
			strSql.Append("SMASTERCARDCODE=:SMASTERCARDCODE,");
			strSql.Append("COLUMN2=:COLUMN2,");
			strSql.Append("COLUMN3=:COLUMN3,");
			strSql.Append("COLUMN4=:COLUMN4,");
			strSql.Append("COLUMN5=:COLUMN5,");
			strSql.Append("COLUMN6=:COLUMN6,");
			strSql.Append("COLUMN7=:COLUMN7,");
			strSql.Append("COLUMN8=:COLUMN8,");
			strSql.Append("COLUMN9=:COLUMN9,");
			strSql.Append("COLUMN10=:COLUMN10,");
			strSql.Append("COLUMN11=:COLUMN11,");
			strSql.Append("COLUMN12=:COLUMN12,");
			strSql.Append("COLUMN13=:COLUMN13,");
			strSql.Append("COLUMN14=:COLUMN14,");
			strSql.Append("COLUMN15=:COLUMN15,");
			strSql.Append("COLUMN16=:COLUMN16,");
			strSql.Append("COLUMN17=:COLUMN17,");
			strSql.Append("COLUMN18=:COLUMN18,");
			strSql.Append("COLUMN19=:COLUMN19,");
			strSql.Append("COLUMN20=:COLUMN20,");
			strSql.Append("COLUMN21=:COLUMN21,");
			strSql.Append("COLUMN22=:COLUMN22,");
			strSql.Append("COLUMN23=:COLUMN23,");
			strSql.Append("COLUMN24=:COLUMN24,");
			strSql.Append("COLUMN25=:COLUMN25,");
			strSql.Append("COLUMN26=:COLUMN26,");
			strSql.Append("COLUMN27=:COLUMN27,");
			strSql.Append("COLUMN28=:COLUMN28,");
			strSql.Append("COLUMN29=:COLUMN29,");
			strSql.Append("COLUMN30=:COLUMN30,");
			strSql.Append("COLUMN31=:COLUMN31,");
			strSql.Append("COLUMN32=:COLUMN32,");
			strSql.Append("COLUMN33=:COLUMN33,");
			strSql.Append("COLUMN34=:COLUMN34,");
			strSql.Append("COLUMN35=:COLUMN35,");
			strSql.Append("COLUMN36=:COLUMN36,");
			strSql.Append("COLUMN37=:COLUMN37,");
			strSql.Append("COLUMN38=:COLUMN38,");
			strSql.Append("COLUMN39=:COLUMN39,");
			strSql.Append("COLUMN40=:COLUMN40,");
			strSql.Append("COLUMN41=:COLUMN41,");
			strSql.Append("COLUMN42=:COLUMN42,");
			strSql.Append("COLUMN43=:COLUMN43,");
			strSql.Append("COLUMN44=:COLUMN44,");
			strSql.Append("COLUMN45=:COLUMN45,");
			strSql.Append("COLUMN46=:COLUMN46,");
			strSql.Append("COLUMN47=:COLUMN47,");
			strSql.Append("COLUMN48=:COLUMN48,");
			strSql.Append("COLUMN49=:COLUMN49,");
			strSql.Append("COLUMN50=:COLUMN50,");
			strSql.Append("COLUMN51=:COLUMN51,");
			strSql.Append("COLUMN52=:COLUMN52,");
			strSql.Append("COLUMN53=:COLUMN53,");
			strSql.Append("COLUMN54=:COLUMN54,");
			strSql.Append("COLUMN55=:COLUMN55,");
			strSql.Append("COLUMN56=:COLUMN56");
			strSql.Append(" where ");
			OracleParameter[] parameters = {
					new OracleParameter(":SCORPCODE", OracleType.VarChar,20),
					new OracleParameter(":SMASTERCARDCODE", OracleType.VarChar,20),
					new OracleParameter(":COLUMN2", OracleType.VarChar,50),
					new OracleParameter(":COLUMN3", OracleType.VarChar,80),
					new OracleParameter(":COLUMN4", OracleType.VarChar,20),
					new OracleParameter(":COLUMN5", OracleType.VarChar,20),
					new OracleParameter(":COLUMN6", OracleType.VarChar,20),
					new OracleParameter(":COLUMN7", OracleType.VarChar,20),
					new OracleParameter(":COLUMN8", OracleType.VarChar,200),
					new OracleParameter(":COLUMN9", OracleType.VarChar,80),
					new OracleParameter(":COLUMN10", OracleType.VarChar,20),
					new OracleParameter(":COLUMN11", OracleType.VarChar,20),
					new OracleParameter(":COLUMN12", OracleType.VarChar,20),
					new OracleParameter(":COLUMN13", OracleType.VarChar,20),
					new OracleParameter(":COLUMN14", OracleType.VarChar,20),
					new OracleParameter(":COLUMN15", OracleType.VarChar,20),
					new OracleParameter(":COLUMN16", OracleType.VarChar,20),
					new OracleParameter(":COLUMN17", OracleType.VarChar,80),
					new OracleParameter(":COLUMN18", OracleType.VarChar,80),
					new OracleParameter(":COLUMN19", OracleType.VarChar,20),
					new OracleParameter(":COLUMN20", OracleType.VarChar,20),
					new OracleParameter(":COLUMN21", OracleType.VarChar,20),
					new OracleParameter(":COLUMN22", OracleType.VarChar,20),
					new OracleParameter(":COLUMN23", OracleType.VarChar,20),
					new OracleParameter(":COLUMN24", OracleType.VarChar,20),
					new OracleParameter(":COLUMN25", OracleType.VarChar,20),
					new OracleParameter(":COLUMN26", OracleType.VarChar,80),
					new OracleParameter(":COLUMN27", OracleType.VarChar,20),
					new OracleParameter(":COLUMN28", OracleType.VarChar,80),
					new OracleParameter(":COLUMN29", OracleType.VarChar,80),
					new OracleParameter(":COLUMN30", OracleType.VarChar,20),
					new OracleParameter(":COLUMN31", OracleType.VarChar,20),
					new OracleParameter(":COLUMN32", OracleType.VarChar,20),
					new OracleParameter(":COLUMN33", OracleType.VarChar,20),
					new OracleParameter(":COLUMN34", OracleType.VarChar,20),
					new OracleParameter(":COLUMN35", OracleType.VarChar,20),
					new OracleParameter(":COLUMN36", OracleType.VarChar,20),
					new OracleParameter(":COLUMN37", OracleType.VarChar,20),
					new OracleParameter(":COLUMN38", OracleType.VarChar,20),
					new OracleParameter(":COLUMN39", OracleType.VarChar,20),
					new OracleParameter(":COLUMN40", OracleType.VarChar,80),
					new OracleParameter(":COLUMN41", OracleType.VarChar,20),
					new OracleParameter(":COLUMN42", OracleType.VarChar,20),
					new OracleParameter(":COLUMN43", OracleType.VarChar,20),
					new OracleParameter(":COLUMN44", OracleType.VarChar,20),
					new OracleParameter(":COLUMN45", OracleType.VarChar,20),
					new OracleParameter(":COLUMN46", OracleType.VarChar,20),
					new OracleParameter(":COLUMN47", OracleType.VarChar,80),
					new OracleParameter(":COLUMN48", OracleType.VarChar,80),
					new OracleParameter(":COLUMN49", OracleType.VarChar,20),
					new OracleParameter(":COLUMN50", OracleType.VarChar,20),
					new OracleParameter(":COLUMN51", OracleType.VarChar,20),
					new OracleParameter(":COLUMN52", OracleType.VarChar,20),
					new OracleParameter(":COLUMN53", OracleType.VarChar,20),
					new OracleParameter(":COLUMN54", OracleType.VarChar,20),
					new OracleParameter(":COLUMN55", OracleType.VarChar,80),
					new OracleParameter(":COLUMN56", OracleType.VarChar,80)};
			parameters[0].Value = model.SCORPCODE;
			parameters[1].Value = model.SMASTERCARDCODE;
			parameters[2].Value = model.COLUMN2;
			parameters[3].Value = model.COLUMN3;
			parameters[4].Value = model.COLUMN4;
			parameters[5].Value = model.COLUMN5;
			parameters[6].Value = model.COLUMN6;
			parameters[7].Value = model.COLUMN7;
			parameters[8].Value = model.COLUMN8;
			parameters[9].Value = model.COLUMN9;
			parameters[10].Value = model.COLUMN10;
			parameters[11].Value = model.COLUMN11;
			parameters[12].Value = model.COLUMN12;
			parameters[13].Value = model.COLUMN13;
			parameters[14].Value = model.COLUMN14;
			parameters[15].Value = model.COLUMN15;
			parameters[16].Value = model.COLUMN16;
			parameters[17].Value = model.COLUMN17;
			parameters[18].Value = model.COLUMN18;
			parameters[19].Value = model.COLUMN19;
			parameters[20].Value = model.COLUMN20;
			parameters[21].Value = model.COLUMN21;
			parameters[22].Value = model.COLUMN22;
			parameters[23].Value = model.COLUMN23;
			parameters[24].Value = model.COLUMN24;
			parameters[25].Value = model.COLUMN25;
			parameters[26].Value = model.COLUMN26;
			parameters[27].Value = model.COLUMN27;
			parameters[28].Value = model.COLUMN28;
			parameters[29].Value = model.COLUMN29;
			parameters[30].Value = model.COLUMN30;
			parameters[31].Value = model.COLUMN31;
			parameters[32].Value = model.COLUMN32;
			parameters[33].Value = model.COLUMN33;
			parameters[34].Value = model.COLUMN34;
			parameters[35].Value = model.COLUMN35;
			parameters[36].Value = model.COLUMN36;
			parameters[37].Value = model.COLUMN37;
			parameters[38].Value = model.COLUMN38;
			parameters[39].Value = model.COLUMN39;
			parameters[40].Value = model.COLUMN40;
			parameters[41].Value = model.COLUMN41;
			parameters[42].Value = model.COLUMN42;
			parameters[43].Value = model.COLUMN43;
			parameters[44].Value = model.COLUMN44;
			parameters[45].Value = model.COLUMN45;
			parameters[46].Value = model.COLUMN46;
			parameters[47].Value = model.COLUMN47;
			parameters[48].Value = model.COLUMN48;
			parameters[49].Value = model.COLUMN49;
			parameters[50].Value = model.COLUMN50;
			parameters[51].Value = model.COLUMN51;
			parameters[52].Value = model.COLUMN52;
			parameters[53].Value = model.COLUMN53;
			parameters[54].Value = model.COLUMN54;
			parameters[55].Value = model.COLUMN55;
			parameters[56].Value = model.COLUMN56;

			int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

		/// <summary>
		/// 删除一条数据
		/// </summary>
		public bool Delete()
		{
			//该表无主键信息，请自定义主键/条件字段
			StringBuilder strSql=new StringBuilder();
			strSql.Append("delete from FA_MASTERDATA_EXCEL_JW ");
			strSql.Append(" where ");
			OracleParameter[] parameters = {
			};

			int rows=DbHelperOra.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}


		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public TKFA.Model.FA_MASTERDATA_EXCEL_JW GetModel()
		{
			//该表无主键信息，请自定义主键/条件字段
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select SCORPCODE,SMASTERCARDCODE,COLUMN2,COLUMN3,COLUMN4,COLUMN5,COLUMN6,COLUMN7,COLUMN8,COLUMN9,COLUMN10,COLUMN11,COLUMN12,COLUMN13,COLUMN14,COLUMN15,COLUMN16,COLUMN17,COLUMN18,COLUMN19,COLUMN20,COLUMN21,COLUMN22,COLUMN23,COLUMN24,COLUMN25,COLUMN26,COLUMN27,COLUMN28,COLUMN29,COLUMN30,COLUMN31,COLUMN32,COLUMN33,COLUMN34,COLUMN35,COLUMN36,COLUMN37,COLUMN38,COLUMN39,COLUMN40,COLUMN41,COLUMN42,COLUMN43,COLUMN44,COLUMN45,COLUMN46,COLUMN47,COLUMN48,COLUMN49,COLUMN50,COLUMN51,COLUMN52,COLUMN53,COLUMN54,COLUMN55,COLUMN56 from FA_MASTERDATA_EXCEL_JW ");
			strSql.Append(" where ");
			OracleParameter[] parameters = {
			};

			TKFA.Model.FA_MASTERDATA_EXCEL_JW model=new TKFA.Model.FA_MASTERDATA_EXCEL_JW();
			DataSet ds=DbHelperOra.Query(strSql.ToString(),parameters);
			if(ds.Tables[0].Rows.Count>0)
			{
				return DataRowToModel(ds.Tables[0].Rows[0]);
			}
			else
			{
				return null;
			}
		}


		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public TKFA.Model.FA_MASTERDATA_EXCEL_JW DataRowToModel(DataRow row)
		{
			TKFA.Model.FA_MASTERDATA_EXCEL_JW model=new TKFA.Model.FA_MASTERDATA_EXCEL_JW();
			if (row != null)
			{
				if(row["SCORPCODE"]!=null)
				{
					model.SCORPCODE=row["SCORPCODE"].ToString();
				}
				if(row["SMASTERCARDCODE"]!=null)
				{
					model.SMASTERCARDCODE=row["SMASTERCARDCODE"].ToString();
				}
				if(row["COLUMN2"]!=null)
				{
					model.COLUMN2=row["COLUMN2"].ToString();
				}
				if(row["COLUMN3"]!=null)
				{
					model.COLUMN3=row["COLUMN3"].ToString();
				}
				if(row["COLUMN4"]!=null)
				{
					model.COLUMN4=row["COLUMN4"].ToString();
				}
				if(row["COLUMN5"]!=null)
				{
					model.COLUMN5=row["COLUMN5"].ToString();
				}
				if(row["COLUMN6"]!=null)
				{
					model.COLUMN6=row["COLUMN6"].ToString();
				}
				if(row["COLUMN7"]!=null)
				{
					model.COLUMN7=row["COLUMN7"].ToString();
				}
				if(row["COLUMN8"]!=null)
				{
					model.COLUMN8=row["COLUMN8"].ToString();
				}
				if(row["COLUMN9"]!=null)
				{
					model.COLUMN9=row["COLUMN9"].ToString();
				}
				if(row["COLUMN10"]!=null)
				{
					model.COLUMN10=row["COLUMN10"].ToString();
				}
				if(row["COLUMN11"]!=null)
				{
					model.COLUMN11=row["COLUMN11"].ToString();
				}
				if(row["COLUMN12"]!=null)
				{
					model.COLUMN12=row["COLUMN12"].ToString();
				}
				if(row["COLUMN13"]!=null)
				{
					model.COLUMN13=row["COLUMN13"].ToString();
				}
				if(row["COLUMN14"]!=null)
				{
					model.COLUMN14=row["COLUMN14"].ToString();
				}
				if(row["COLUMN15"]!=null)
				{
					model.COLUMN15=row["COLUMN15"].ToString();
				}
				if(row["COLUMN16"]!=null)
				{
					model.COLUMN16=row["COLUMN16"].ToString();
				}
				if(row["COLUMN17"]!=null)
				{
					model.COLUMN17=row["COLUMN17"].ToString();
				}
				if(row["COLUMN18"]!=null)
				{
					model.COLUMN18=row["COLUMN18"].ToString();
				}
				if(row["COLUMN19"]!=null)
				{
					model.COLUMN19=row["COLUMN19"].ToString();
				}
				if(row["COLUMN20"]!=null)
				{
					model.COLUMN20=row["COLUMN20"].ToString();
				}
				if(row["COLUMN21"]!=null)
				{
					model.COLUMN21=row["COLUMN21"].ToString();
				}
				if(row["COLUMN22"]!=null)
				{
					model.COLUMN22=row["COLUMN22"].ToString();
				}
				if(row["COLUMN23"]!=null)
				{
					model.COLUMN23=row["COLUMN23"].ToString();
				}
				if(row["COLUMN24"]!=null)
				{
					model.COLUMN24=row["COLUMN24"].ToString();
				}
				if(row["COLUMN25"]!=null)
				{
					model.COLUMN25=row["COLUMN25"].ToString();
				}
				if(row["COLUMN26"]!=null)
				{
					model.COLUMN26=row["COLUMN26"].ToString();
				}
				if(row["COLUMN27"]!=null)
				{
					model.COLUMN27=row["COLUMN27"].ToString();
				}
				if(row["COLUMN28"]!=null)
				{
					model.COLUMN28=row["COLUMN28"].ToString();
				}
				if(row["COLUMN29"]!=null)
				{
					model.COLUMN29=row["COLUMN29"].ToString();
				}
				if(row["COLUMN30"]!=null)
				{
					model.COLUMN30=row["COLUMN30"].ToString();
				}
				if(row["COLUMN31"]!=null)
				{
					model.COLUMN31=row["COLUMN31"].ToString();
				}
				if(row["COLUMN32"]!=null)
				{
					model.COLUMN32=row["COLUMN32"].ToString();
				}
				if(row["COLUMN33"]!=null)
				{
					model.COLUMN33=row["COLUMN33"].ToString();
				}
				if(row["COLUMN34"]!=null)
				{
					model.COLUMN34=row["COLUMN34"].ToString();
				}
				if(row["COLUMN35"]!=null)
				{
					model.COLUMN35=row["COLUMN35"].ToString();
				}
				if(row["COLUMN36"]!=null)
				{
					model.COLUMN36=row["COLUMN36"].ToString();
				}
				if(row["COLUMN37"]!=null)
				{
					model.COLUMN37=row["COLUMN37"].ToString();
				}
				if(row["COLUMN38"]!=null)
				{
					model.COLUMN38=row["COLUMN38"].ToString();
				}
				if(row["COLUMN39"]!=null)
				{
					model.COLUMN39=row["COLUMN39"].ToString();
				}
				if(row["COLUMN40"]!=null)
				{
					model.COLUMN40=row["COLUMN40"].ToString();
				}
				if(row["COLUMN41"]!=null)
				{
					model.COLUMN41=row["COLUMN41"].ToString();
				}
				if(row["COLUMN42"]!=null)
				{
					model.COLUMN42=row["COLUMN42"].ToString();
				}
				if(row["COLUMN43"]!=null)
				{
					model.COLUMN43=row["COLUMN43"].ToString();
				}
				if(row["COLUMN44"]!=null)
				{
					model.COLUMN44=row["COLUMN44"].ToString();
				}
				if(row["COLUMN45"]!=null)
				{
					model.COLUMN45=row["COLUMN45"].ToString();
				}
				if(row["COLUMN46"]!=null)
				{
					model.COLUMN46=row["COLUMN46"].ToString();
				}
				if(row["COLUMN47"]!=null)
				{
					model.COLUMN47=row["COLUMN47"].ToString();
				}
				if(row["COLUMN48"]!=null)
				{
					model.COLUMN48=row["COLUMN48"].ToString();
				}
				if(row["COLUMN49"]!=null)
				{
					model.COLUMN49=row["COLUMN49"].ToString();
				}
				if(row["COLUMN50"]!=null)
				{
					model.COLUMN50=row["COLUMN50"].ToString();
				}
				if(row["COLUMN51"]!=null)
				{
					model.COLUMN51=row["COLUMN51"].ToString();
				}
				if(row["COLUMN52"]!=null)
				{
					model.COLUMN52=row["COLUMN52"].ToString();
				}
				if(row["COLUMN53"]!=null)
				{
					model.COLUMN53=row["COLUMN53"].ToString();
				}
				if(row["COLUMN54"]!=null)
				{
					model.COLUMN54=row["COLUMN54"].ToString();
				}
				if(row["COLUMN55"]!=null)
				{
					model.COLUMN55=row["COLUMN55"].ToString();
				}
				if(row["COLUMN56"]!=null)
				{
					model.COLUMN56=row["COLUMN56"].ToString();
				}
			}
			return model;
		}

		/// <summary>
		/// 获得数据列表
		/// </summary>
		public DataSet GetList(string strWhere)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select SCORPCODE,SMASTERCARDCODE,COLUMN2,COLUMN3,COLUMN4,COLUMN5,COLUMN6,COLUMN7,COLUMN8,COLUMN9,COLUMN10,COLUMN11,COLUMN12,COLUMN13,COLUMN14,COLUMN15,COLUMN16,COLUMN17,COLUMN18,COLUMN19,COLUMN20,COLUMN21,COLUMN22,COLUMN23,COLUMN24,COLUMN25,COLUMN26,COLUMN27,COLUMN28,COLUMN29,COLUMN30,COLUMN31,COLUMN32,COLUMN33,COLUMN34,COLUMN35,COLUMN36,COLUMN37,COLUMN38,COLUMN39,COLUMN40,COLUMN41,COLUMN42,COLUMN43,COLUMN44,COLUMN45,COLUMN46,COLUMN47,COLUMN48,COLUMN49,COLUMN50,COLUMN51,COLUMN52,COLUMN53,COLUMN54,COLUMN55,COLUMN56 ");
			strSql.Append(" FROM FA_MASTERDATA_EXCEL_JW ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			return DbHelperOra.Query(strSql.ToString());
		}

		/// <summary>
		/// 获取记录总数
		/// </summary>
		public int GetRecordCount(string strWhere)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) FROM FA_MASTERDATA_EXCEL_JW ");
			if(strWhere.Trim()!="")
			{
				strSql.Append(" where "+strWhere);
			}
			object obj = DbHelperSQL.GetSingle(strSql.ToString());
			if (obj == null)
			{
				return 0;
			}
			else
			{
				return Convert.ToInt32(obj);
			}
		}
		/// <summary>
		/// 分页获取数据列表
		/// </summary>
		public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("SELECT * FROM ( ");
			strSql.Append(" SELECT ROW_NUMBER() OVER (");
			if (!string.IsNullOrEmpty(orderby.Trim()))
			{
				strSql.Append("order by T." + orderby );
			}
			else
			{
				strSql.Append("order by T.SCODE desc");
			}
			strSql.Append(")AS Row, T.*  from FA_MASTERDATA_EXCEL_JW T ");
			if (!string.IsNullOrEmpty(strWhere.Trim()))
			{
				strSql.Append(" WHERE " + strWhere);
			}
			strSql.Append(" ) TT");
			strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
			return DbHelperOra.Query(strSql.ToString());
		}

		/*
		/// <summary>
		/// 分页获取数据列表
		/// </summary>
		public DataSet GetList(int PageSize,int PageIndex,string strWhere)
		{
			OracleParameter[] parameters = {
					new OracleParameter(":tblName", OracleType.VarChar, 255),
					new OracleParameter(":fldName", OracleType.VarChar, 255),
					new OracleParameter(":PageSize", OracleType.Number),
					new OracleParameter(":PageIndex", OracleType.Number),
					new OracleParameter(":IsReCount", OracleType.Clob),
					new OracleParameter(":OrderType", OracleType.Clob),
					new OracleParameter(":strWhere", OracleType.VarChar,1000),
					};
			parameters[0].Value = "FA_MASTERDATA_EXCEL_JW";
			parameters[1].Value = "SCODE";
			parameters[2].Value = PageSize;
			parameters[3].Value = PageIndex;
			parameters[4].Value = 0;
			parameters[5].Value = 0;
			parameters[6].Value = strWhere;	
			return DbHelperOra.RunProcedure("UP_GetRecordByPage",parameters,"ds");
		}*/

		#endregion  BasicMethod
		#region  ExtensionMethod

		#endregion  ExtensionMethod
	}
}

